<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="TeamDataSet" targetNamespace="http://www.badhabit.com/XMLSchema/2008/TeamDataSet.xsd" xmlns:mstns="http://www.badhabit.com/XMLSchema/2008/TeamDataSet.xsd" xmlns="http://www.badhabit.com/XMLSchema/2008/TeamDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DataSetFile="TeamDataSet.Dataset.Designer.cs" DataSetProject="FactoryCore" DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="FactoryConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="FactoryConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.BadHabit.Factory.Data.Properties.Settings.GlobalReference.Default.FactoryConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="FactoryConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="FactoryConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.BadHabit.Factory.Data.Properties.Settings.GlobalReference.Default.FactoryConnectionString1" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MemberTableAdapter" GeneratorDataComponentClassName="MemberTableAdapter" Name="Member" UserDataComponentName="MemberTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.Member" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM factory.[Member] WHERE (([MemberId] = @Original_MemberId) AND ([DefaultUnitName] = @Original_DefaultUnitName) AND ([NickName] = @Original_NickName) AND ([FactoryOwnerRole] = @Original_FactoryOwnerRole) AND ([ScrumMasterRole] = @Original_ScrumMasterRole) AND ([TeamRole] = @Original_TeamRole) AND ([ProductOwnerRole] = @Original_ProductOwnerRole) AND ([CommercialGuyRole] = @Original_CommercialGuyRole) AND ((@IsNull_EmailAccount = 1 AND [EmailAccount] IS NULL) OR ([EmailAccount] = @Original_EmailAccount)) AND ((@IsNull_ContactData = 1 AND [ContactData] IS NULL) OR ([ContactData] = @Original_ContactData)) AND ([Company] = @Original_Company) AND ([ClientContactRole] = @Original_ClientContactRole) AND ((@IsNull_AccessKey = 1 AND [AccessKey] IS NULL) OR ([AccessKey] = @Original_AccessKey)) AND ([QualityAssuranceRole] = @Original_QualityAssuranceRole))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MemberId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MemberId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DefaultUnitName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DefaultUnitName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NickName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NickName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_FactoryOwnerRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FactoryOwnerRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ScrumMasterRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ScrumMasterRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_TeamRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TeamRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ProductOwnerRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ProductOwnerRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_CommercialGuyRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CommercialGuyRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmailAccount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmailAccount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EmailAccount" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmailAccount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactData" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactData" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ContactData" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ContactData" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Company" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ClientContactRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ClientContactRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AccessKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccessKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_AccessKey" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="AccessKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_QualityAssuranceRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="QualityAssuranceRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>
                      INSERT INTO factory.[Member] ([MemberId], [DefaultUnitName], [NickName], [FactoryOwnerRole], [ScrumMasterRole], [TeamRole], [ProductOwnerRole], [CommercialGuyRole], [EmailAccount], [ContactData], [Company], [ClientContactRole], [AccessKey], [QualityAssuranceRole]) VALUES (@MemberId, @DefaultUnitName, @NickName, @FactoryOwnerRole, @ScrumMasterRole, @TeamRole, @ProductOwnerRole, @CommercialGuyRole, @EmailAccount, @ContactData, @Company, @ClientContactRole, @AccessKey, @QualityAssuranceRole);
                      SELECT MemberId, DefaultUnitName, NickName, FactoryOwnerRole, ScrumMasterRole, TeamRole, ProductOwnerRole, CommercialGuyRole, EmailAccount, ContactData, Company, ClientContactRole, AccessKey, QualityAssuranceRole FROM factory.Member WHERE (MemberId = @MemberId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MemberId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MemberId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DefaultUnitName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DefaultUnitName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NickName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NickName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@FactoryOwnerRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FactoryOwnerRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ScrumMasterRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ScrumMasterRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@TeamRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TeamRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ProductOwnerRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ProductOwnerRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@CommercialGuyRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CommercialGuyRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmailAccount" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmailAccount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ContactData" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ContactData" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Company" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ClientContactRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ClientContactRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@AccessKey" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="AccessKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@QualityAssuranceRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="QualityAssuranceRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT MemberId, DefaultUnitName, NickName, FactoryOwnerRole, ScrumMasterRole, TeamRole, ProductOwnerRole, CommercialGuyRole, EmailAccount, ContactData, Company, ClientContactRole, AccessKey, QualityAssuranceRole FROM factory.Member</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>
                      UPDATE factory.[Member] SET [MemberId] = @MemberId, [DefaultUnitName] = @DefaultUnitName, [NickName] = @NickName, [FactoryOwnerRole] = @FactoryOwnerRole, [ScrumMasterRole] = @ScrumMasterRole, [TeamRole] = @TeamRole, [ProductOwnerRole] = @ProductOwnerRole, [CommercialGuyRole] = @CommercialGuyRole, [EmailAccount] = @EmailAccount, [ContactData] = @ContactData, [Company] = @Company, [ClientContactRole] = @ClientContactRole, [AccessKey] = @AccessKey, [QualityAssuranceRole] = @QualityAssuranceRole WHERE (([MemberId] = @Original_MemberId) AND ([DefaultUnitName] = @Original_DefaultUnitName) AND ([NickName] = @Original_NickName) AND ([FactoryOwnerRole] = @Original_FactoryOwnerRole) AND ([ScrumMasterRole] = @Original_ScrumMasterRole) AND ([TeamRole] = @Original_TeamRole) AND ([ProductOwnerRole] = @Original_ProductOwnerRole) AND ([CommercialGuyRole] = @Original_CommercialGuyRole) AND ((@IsNull_EmailAccount = 1 AND [EmailAccount] IS NULL) OR ([EmailAccount] = @Original_EmailAccount)) AND ((@IsNull_ContactData = 1 AND [ContactData] IS NULL) OR ([ContactData] = @Original_ContactData)) AND ([Company] = @Original_Company) AND ([ClientContactRole] = @Original_ClientContactRole) AND ((@IsNull_AccessKey = 1 AND [AccessKey] IS NULL) OR ([AccessKey] = @Original_AccessKey)) AND ([QualityAssuranceRole] = @Original_QualityAssuranceRole));
                      SELECT MemberId, DefaultUnitName, NickName, FactoryOwnerRole, ScrumMasterRole, TeamRole, ProductOwnerRole, CommercialGuyRole, EmailAccount, ContactData, Company, ClientContactRole, AccessKey, QualityAssuranceRole FROM factory.Member WHERE (MemberId = @MemberId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MemberId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MemberId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DefaultUnitName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DefaultUnitName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NickName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NickName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@FactoryOwnerRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FactoryOwnerRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ScrumMasterRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ScrumMasterRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@TeamRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TeamRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ProductOwnerRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ProductOwnerRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@CommercialGuyRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CommercialGuyRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmailAccount" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmailAccount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ContactData" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ContactData" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Company" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ClientContactRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ClientContactRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@AccessKey" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="AccessKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@QualityAssuranceRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="QualityAssuranceRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MemberId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MemberId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DefaultUnitName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DefaultUnitName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NickName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NickName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_FactoryOwnerRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="FactoryOwnerRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ScrumMasterRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ScrumMasterRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_TeamRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TeamRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ProductOwnerRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ProductOwnerRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_CommercialGuyRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CommercialGuyRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmailAccount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmailAccount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EmailAccount" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmailAccount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactData" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactData" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ContactData" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ContactData" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Company" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ClientContactRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ClientContactRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AccessKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccessKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_AccessKey" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="AccessKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_QualityAssuranceRole" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="QualityAssuranceRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MemberId" DataSetColumn="MemberId" />
              <Mapping SourceColumn="DefaultUnitName" DataSetColumn="DefaultUnitName" />
              <Mapping SourceColumn="NickName" DataSetColumn="NickName" />
              <Mapping SourceColumn="FactoryOwnerRole" DataSetColumn="FactoryOwnerRole" />
              <Mapping SourceColumn="ScrumMasterRole" DataSetColumn="ScrumMasterRole" />
              <Mapping SourceColumn="TeamRole" DataSetColumn="TeamRole" />
              <Mapping SourceColumn="ProductOwnerRole" DataSetColumn="ProductOwnerRole" />
              <Mapping SourceColumn="CommercialGuyRole" DataSetColumn="CommercialGuyRole" />
              <Mapping SourceColumn="EmailAccount" DataSetColumn="EmailAccount" />
              <Mapping SourceColumn="ContactData" DataSetColumn="ContactData" />
              <Mapping SourceColumn="Company" DataSetColumn="Company" />
              <Mapping SourceColumn="ExternalMember" DataSetColumn="ClientContactRole" />
              <Mapping SourceColumn="AccessKey" DataSetColumn="AccessKey" />
              <Mapping SourceColumn="ClientContactRole" DataSetColumn="ClientContactRole" />
              <Mapping SourceColumn="QualityAssuranceRole" DataSetColumn="QualityAssuranceRole" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.Member" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCompany" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCompany" GeneratorSourceName="FillByCompany" GetMethodModifier="Public" GetMethodName="GetDataByCompany" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCompany" UserSourceName="FillByCompany">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AccessKey, ClientContactRole, CommercialGuyRole, Company, ContactData, DefaultUnitName, EmailAccount, FactoryOwnerRole, MemberId, NickName, ProductOwnerRole, QualityAssuranceRole, ScrumMasterRole, TeamRole FROM factory.Member WHERE (Company = @Company)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Company" ColumnName="Company" DataSourceName="Factory.factory.Member" DataTypeServer="nvarchar(255)" DbType="String" Direction="Input" ParameterName="@Company" Precision="0" ProviderType="NVarChar" Scale="0" Size="255" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory_v1.factory.Member" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBySameProjectMemberId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBySameProjectMemberId" GeneratorSourceName="FillBySameProjectMemberId" GetMethodModifier="Public" GetMethodName="GetDataBySameProjectMemberId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBySameProjectMemberId" UserSourceName="FillBySameProjectMemberId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AccessKey, ClientContactRole, CommercialGuyRole, Company, ContactData, DefaultUnitName, EmailAccount, FactoryOwnerRole, MemberId, NickName, ProductOwnerRole, QualityAssuranceRole, ScrumMasterRole, TeamRole FROM factory.Member WHERE (MemberId IN (SELECT DISTINCT ContactId FROM factory.ProjectRole AS pr WHERE EXISTS (SELECT 1 AS Expr1 FROM factory.ProjectRole AS pr2 INNER JOIN factory.Project AS p ON pr2.ProjectUId = p.ProjectUId WHERE (pr2.ProjectUId = pr.ProjectUId) AND (p.Status NOT IN (4, 8, 9, 10)) AND (pr2.ContactId = @TeamMemberId))))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="TeamMemberId" ColumnName="" DataSourceName="" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@TeamMemberId" Precision="0" Scale="0" Size="255" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.Member" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillClientContactMembers" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetClientContactMembersData" GeneratorSourceName="FillClientContactMembers" GetMethodModifier="Public" GetMethodName="GetClientContactMembersData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetClientContactMembersData" UserSourceName="FillClientContactMembers">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AccessKey, ClientContactRole, CommercialGuyRole, Company, ContactData, DefaultUnitName, EmailAccount, FactoryOwnerRole, MemberId, NickName, ProductOwnerRole, QualityAssuranceRole, ScrumMasterRole, TeamRole FROM factory.Member WHERE (ClientContactRole = 1)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory_v1.factory.Member" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillCompanyMembers" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetCompanyMembersData" GeneratorSourceName="FillCompanyMembers" GetMethodModifier="Public" GetMethodName="GetCompanyMembersData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCompanyMembersData" UserSourceName="FillCompanyMembers">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AccessKey, ClientContactRole, CommercialGuyRole, Company, ContactData, DefaultUnitName, EmailAccount, FactoryOwnerRole, MemberId, NickName, ProductOwnerRole, QualityAssuranceRole, ScrumMasterRole, TeamRole FROM factory.Member WHERE (ClientContactRole = 0)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DistinctCompanyTableAdapter" GeneratorDataComponentClassName="DistinctCompanyTableAdapter" Name="DistinctCompany" UserDataComponentName="DistinctCompanyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory_v1.factory.Member" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT DISTINCT Company FROM factory.Member WHERE ClientContactRole=1</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Company" DataSetColumn="Company" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MemberAllocationTableAdapter" GeneratorDataComponentClassName="MemberAllocationTableAdapter" Name="MemberAllocation" UserDataComponentName="MemberAllocationTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory_v1.factory.MemberAllocation" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT MemberId, ProjectCount, AvailableAt FROM factory.MemberAllocation</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MemberId" DataSetColumn="MemberId" />
              <Mapping SourceColumn="ProjectCount" DataSetColumn="ProjectCount" />
              <Mapping SourceColumn="AvailableAt" DataSetColumn="AvailableAt" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MemberAvatarTableAdapter" GeneratorDataComponentClassName="MemberAvatarTableAdapter" Name="MemberAvatar" UserDataComponentName="MemberAvatarTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory_v1.factory.MemberAvatar" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [factory].[MemberAvatar] WHERE (([MemberId] = @Original_MemberId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MemberId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MemberId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [factory].[MemberAvatar] ([MemberId], [MemberImage]) VALUES (@MemberId, @MemberImage);
SELECT MemberId, MemberImage FROM factory.MemberAvatar WHERE (MemberId = @MemberId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MemberId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MemberId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@MemberImage" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="MemberImage" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT MemberId, MemberImage FROM factory.MemberAvatar</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [factory].[MemberAvatar] SET [MemberId] = @MemberId, [MemberImage] = @MemberImage WHERE (([MemberId] = @Original_MemberId));
SELECT MemberId, MemberImage FROM factory.MemberAvatar WHERE (MemberId = @MemberId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MemberId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MemberId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@MemberImage" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="MemberImage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MemberId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MemberId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MemberId" DataSetColumn="MemberId" />
              <Mapping SourceColumn="MemberImage" DataSetColumn="MemberImage" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory_v1.factory.MemberAvatar" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByMemberId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByMemberId" GeneratorSourceName="FillByMemberId" GetMethodModifier="Public" GetMethodName="GetDataByMemberId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByMemberId" UserSourceName="FillByMemberId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT MemberId, MemberImage FROM factory.MemberAvatar WHERE MemberId = @MemberId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="MemberId" ColumnName="MemberId" DataSourceName="Factory_v1.factory.MemberAvatar" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@MemberId" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumn="MemberId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="TeamDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="TeamDataSet" msprop:Generator_DataSetName="TeamDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Member" msprop:Generator_UserTableName="Member" msprop:Generator_RowDeletedName="MemberRowDeleted" msprop:Generator_RowChangedName="MemberRowChanged" msprop:Generator_RowClassName="MemberRow" msprop:Generator_RowChangingName="MemberRowChanging" msprop:Generator_RowEvArgName="MemberRowChangeEvent" msprop:Generator_RowEvHandlerName="MemberRowChangeEventHandler" msprop:Generator_TableClassName="MemberDataTable" msprop:Generator_TableVarName="tableMember" msprop:Generator_RowDeletingName="MemberRowDeleting" msprop:Generator_TablePropName="Member">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MemberId" msprop:Generator_UserColumnName="MemberId" msprop:Generator_ColumnVarNameInTable="columnMemberId" msprop:Generator_ColumnPropNameInRow="MemberId" msprop:Generator_ColumnPropNameInTable="MemberIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DefaultUnitName" msprop:Generator_UserColumnName="DefaultUnitName" msprop:Generator_ColumnVarNameInTable="columnDefaultUnitName" msprop:Generator_ColumnPropNameInRow="DefaultUnitName" msprop:Generator_ColumnPropNameInTable="DefaultUnitNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NickName" msprop:Generator_UserColumnName="NickName" msprop:Generator_ColumnVarNameInTable="columnNickName" msprop:Generator_ColumnPropNameInRow="NickName" msprop:Generator_ColumnPropNameInTable="NickNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FactoryOwnerRole" msprop:Generator_UserColumnName="FactoryOwnerRole" msprop:Generator_ColumnVarNameInTable="columnFactoryOwnerRole" msprop:Generator_ColumnPropNameInRow="FactoryOwnerRole" msprop:Generator_ColumnPropNameInTable="FactoryOwnerRoleColumn" type="xs:boolean" />
              <xs:element name="ScrumMasterRole" msprop:Generator_UserColumnName="ScrumMasterRole" msprop:Generator_ColumnVarNameInTable="columnScrumMasterRole" msprop:Generator_ColumnPropNameInRow="ScrumMasterRole" msprop:Generator_ColumnPropNameInTable="ScrumMasterRoleColumn" type="xs:boolean" />
              <xs:element name="TeamRole" msprop:Generator_UserColumnName="TeamRole" msprop:Generator_ColumnVarNameInTable="columnTeamRole" msprop:Generator_ColumnPropNameInRow="TeamRole" msprop:Generator_ColumnPropNameInTable="TeamRoleColumn" type="xs:boolean" />
              <xs:element name="ProductOwnerRole" msprop:Generator_UserColumnName="ProductOwnerRole" msprop:Generator_ColumnVarNameInTable="columnProductOwnerRole" msprop:Generator_ColumnPropNameInRow="ProductOwnerRole" msprop:Generator_ColumnPropNameInTable="ProductOwnerRoleColumn" type="xs:boolean" />
              <xs:element name="CommercialGuyRole" msprop:Generator_UserColumnName="CommercialGuyRole" msprop:Generator_ColumnVarNameInTable="columnCommercialGuyRole" msprop:Generator_ColumnPropNameInRow="CommercialGuyRole" msprop:Generator_ColumnPropNameInTable="CommercialGuyRoleColumn" type="xs:boolean" />
              <xs:element name="EmailAccount" msprop:Generator_UserColumnName="EmailAccount" msprop:Generator_ColumnVarNameInTable="columnEmailAccount" msprop:Generator_ColumnPropNameInRow="EmailAccount" msprop:Generator_ColumnPropNameInTable="EmailAccountColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContactData" msprop:Generator_UserColumnName="ContactData" msprop:Generator_ColumnVarNameInTable="columnContactData" msprop:Generator_ColumnPropNameInRow="ContactData" msprop:Generator_ColumnPropNameInTable="ContactDataColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Company" msprop:Generator_UserColumnName="Company" msprop:Generator_ColumnVarNameInTable="columnCompany" msprop:Generator_ColumnPropNameInRow="Company" msprop:Generator_ColumnPropNameInTable="CompanyColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ClientContactRole" msprop:Generator_UserColumnName="ClientContactRole" msprop:Generator_ColumnVarNameInTable="columnClientContactRole" msprop:Generator_ColumnPropNameInRow="ClientContactRole" msprop:Generator_ColumnPropNameInTable="ClientContactRoleColumn" type="xs:boolean" />
              <xs:element name="AccessKey" msprop:Generator_UserColumnName="AccessKey" msprop:Generator_ColumnVarNameInTable="columnAccessKey" msprop:Generator_ColumnPropNameInRow="AccessKey" msprop:Generator_ColumnPropNameInTable="AccessKeyColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Disable" msprop:Generator_UserColumnName="Disable" msprop:Generator_ColumnPropNameInRow="Disable" msprop:Generator_ColumnVarNameInTable="columnDisable" msprop:Generator_ColumnPropNameInTable="DisableColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="QualityAssuranceRole" msprop:Generator_UserColumnName="QualityAssuranceRole" msprop:Generator_ColumnVarNameInTable="columnQualityAssuranceRole" msprop:Generator_ColumnPropNameInRow="QualityAssuranceRole" msprop:Generator_ColumnPropNameInTable="QualityAssuranceRoleColumn" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DistinctCompany" msprop:Generator_UserTableName="DistinctCompany" msprop:Generator_RowDeletedName="DistinctCompanyRowDeleted" msprop:Generator_RowChangedName="DistinctCompanyRowChanged" msprop:Generator_RowClassName="DistinctCompanyRow" msprop:Generator_RowChangingName="DistinctCompanyRowChanging" msprop:Generator_RowEvArgName="DistinctCompanyRowChangeEvent" msprop:Generator_RowEvHandlerName="DistinctCompanyRowChangeEventHandler" msprop:Generator_TableClassName="DistinctCompanyDataTable" msprop:Generator_TableVarName="tableDistinctCompany" msprop:Generator_RowDeletingName="DistinctCompanyRowDeleting" msprop:Generator_TablePropName="DistinctCompany">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Company" msprop:Generator_UserColumnName="Company" msprop:Generator_ColumnPropNameInRow="Company" msprop:Generator_ColumnVarNameInTable="columnCompany" msprop:Generator_ColumnPropNameInTable="CompanyColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MemberAllocation" msprop:Generator_UserTableName="MemberAllocation" msprop:Generator_RowDeletedName="MemberAllocationRowDeleted" msprop:Generator_RowChangedName="MemberAllocationRowChanged" msprop:Generator_RowClassName="MemberAllocationRow" msprop:Generator_RowChangingName="MemberAllocationRowChanging" msprop:Generator_RowEvArgName="MemberAllocationRowChangeEvent" msprop:Generator_RowEvHandlerName="MemberAllocationRowChangeEventHandler" msprop:Generator_TableClassName="MemberAllocationDataTable" msprop:Generator_TableVarName="tableMemberAllocation" msprop:Generator_RowDeletingName="MemberAllocationRowDeleting" msprop:Generator_TablePropName="MemberAllocation">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MemberId" msprop:Generator_UserColumnName="MemberId" msprop:Generator_ColumnPropNameInRow="MemberId" msprop:Generator_ColumnVarNameInTable="columnMemberId" msprop:Generator_ColumnPropNameInTable="MemberIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProjectCount" msprop:Generator_UserColumnName="ProjectCount" msprop:Generator_ColumnPropNameInRow="ProjectCount" msprop:Generator_ColumnVarNameInTable="columnProjectCount" msprop:Generator_ColumnPropNameInTable="ProjectCountColumn" type="xs:int" minOccurs="0" />
              <xs:element name="AvailableAt" msprop:Generator_UserColumnName="AvailableAt" msprop:Generator_ColumnPropNameInRow="AvailableAt" msprop:Generator_ColumnVarNameInTable="columnAvailableAt" msprop:Generator_ColumnPropNameInTable="AvailableAtColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MemberAvatar" msprop:Generator_UserTableName="MemberAvatar" msprop:Generator_RowDeletedName="MemberAvatarRowDeleted" msprop:Generator_RowChangedName="MemberAvatarRowChanged" msprop:Generator_RowClassName="MemberAvatarRow" msprop:Generator_RowChangingName="MemberAvatarRowChanging" msprop:Generator_RowEvArgName="MemberAvatarRowChangeEvent" msprop:Generator_RowEvHandlerName="MemberAvatarRowChangeEventHandler" msprop:Generator_TableClassName="MemberAvatarDataTable" msprop:Generator_TableVarName="tableMemberAvatar" msprop:Generator_RowDeletingName="MemberAvatarRowDeleting" msprop:Generator_TablePropName="MemberAvatar">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MemberId" msprop:Generator_UserColumnName="MemberId" msprop:Generator_ColumnPropNameInRow="MemberId" msprop:Generator_ColumnVarNameInTable="columnMemberId" msprop:Generator_ColumnPropNameInTable="MemberIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MemberImage" msprop:Generator_UserColumnName="MemberImage" msprop:Generator_ColumnPropNameInRow="MemberImage" msprop:Generator_ColumnVarNameInTable="columnMemberImage" msprop:Generator_ColumnPropNameInTable="MemberImageColumn" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Member" />
      <xs:field xpath="mstns:MemberId" />
    </xs:unique>
    <xs:unique name="MemberAllocation_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MemberAllocation" />
      <xs:field xpath="mstns:MemberId" />
    </xs:unique>
    <xs:unique name="MemberAvatar_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MemberAvatar" />
      <xs:field xpath="mstns:MemberId" />
    </xs:unique>
  </xs:element>
</xs:schema>